StoreSafeTenderHistory(Superceded)

Entity Definition

Logical Name : StoreSafeTenderHistory(Superceded)
Physical Name : LE_HST_STR_SF_TND

An accumulator for various tender amounts and units held and transferred to and from the STORE SAFE for a period bounded by StoreSafeSettlementTransactions.

Data Definition

Attribute Description Physical Name Domain Data Type Foreign Key Table
TransactionID (FK)(PK) A universally unique identifier (UUID) for the Transaction. This may be assembled from alternate key members. ID_TRN IdentityUUID char(32) StoreSafeSettlementDocument(LE_HST_STR_SF)
TenderTypeCode (FK)(PK) A code which uniquely identifies the type of tender, ie cash, check, credit card, etc. TY_TND Code varchar(20) Tender(AS_TND)
SafeID (FK)(PK) The unique identifier for the TENDER RESPOSITORY. ID_RPSTY_TND Identity integer StoreSafeSettlementDocument(LE_HST_STR_SF)
TenderOpenBalanceTotalAmount The monetary amount of the opening balance of the STORE SAFE TENDER by safe settlement period. MO_BLNC_OPN_TND Money decimal(16,5)
TenderLoanTotalAmount The total monetary amount of the tender loans made FROM the SAFE in each safe settlement period. MO_LON_TND_TOT Money decimal(16,5)
TotalTenderLoanCount The total number of tender loans FROM the SAFE by safe settlement period. QU_LON_TND_TOT QuantityTransactionCount decimal(7,0)
TenderPickupTotalAmount The total monetary amount of the tender pickups loans made TO the SAFE by safe settlement period. MO_PKP_TND_TOT Money decimal(16,5)
TotalTenderPickupCount The total number of tender pickupsTO the SAFE by safe settlement period.. QU_PKP_TND_TOT QuantityTransactionCount decimal(7,0)
TenderDepositTotalAmount The total monetary amount of the tender deposits madeFROM the SAFE to the EXTERNAL DEPOSITORY by safe settlement period. MO_DS_TND_TOT Money decimal(16,5)
TenderReceiptTotalAmount The total monetary amount of the tender receipts madeTO the SAFE from the EXTERNAL DEPOSITORY by safe settlement period. MO_RCV_TND_TOT Money decimal(16,5)
OverTenderDiscrepancyTotalAmount The total monetary amount of tender overages recorded for the SAFE by safe settlement period. MO_DSCP_TND_OVR_TOT Money decimal(16,5)
UnderTenderDiscrepancyTotalAmount The total monetary amount of tender shortages recorded for the SAFE by safe settlement period. MO_DSCP_TND_UND Money decimal(16,5)
PettyCashDisbursementTransactionTotalAmount The total monetary amount of cash disbursements made from the SAFE by safe settlement period. MO_DSB_PTY_CSH_TOT Money decimal(16,5)
TotalPettyCashDisbursementTransactionCount The total number of cash disbursements made from the SAFE by safe settlement period. QU_TRN_DSB_PTY_CSH QuantityTransactionCount decimal(7,0)
TotalTenderCountedAmount The actual tender monetary value counted as part of the settlement process. MO_TOT_TND__CNT_AMT Money decimal(16,5)

Relationships

Parent Entity Verb Phrase Child Entity
Tender is tracked by StoreSafeTenderHistory(Superceded)
StoreSafeSettlementDocument may include StoreSafeTenderHistory(Superceded)

No Logical Views for StoreSafeTenderHistory(Superceded)